00问答网
所有问题
当前搜索:
insert select
insert
语句嵌套
select
语句
答:
在VALUES子句中不能有子查询,这样就可以了:
insert
into VoteRecord(IP,TopicNum)
select
'" + ip + "',ID from Topic where [Content]='" + topic + "'实际生成的语句应该这样:insert into VoteRecord(IP,TopicNum) select '192.168.1.1',ID from Topic where [Content]='123'不过,...
SQL命令动词(create,drop,alter,
select
,
insert
,update,delete,grant...
答:
数据查询
SELECT
(查询)数据定义 CREATE(创建表、视图。。。)、DROP(删除表、视图。。。)、ALTER(修改表、视图。。。)、数据操作
INSERT
(添加数据)、UPDATE(修改数据)、DELETE(删除数据)数据控制 GRANT(为用户授权)、REVOKE(废除权限)...
Oracle中
insert
into
select
和select into的区别
答:
转:在Oracle中,将一张表的数据复制到另外一个对象中。通常会有这两种方法:
insert
into
select
和 select into from。前者可以将select 出来的N行(0到任意数)结果集复制一个新表中,后者只能将"一行"结果复制到一个变量中。这样说吧,select into是PL/SQL language 的赋值语句。而前者是标准的...
什么是
select
into from和
insert
into select?
答:
备份表数据: create table emp as
select
* from scott.emp 还原表数据:
insert
into emp select * from scott.emp 复制表结构及其数据:create table table_name_new as select * from table_name_old 只复制表结构:create table table_name_new as select * from table_name_old where 1=2;...
select
into from和
insert
into select都是用来复制表,两者有什么区别...
答:
备份表数据: create table emp as
select
* from scott.emp 还原表数据:
insert
into emp select * from scott.emp 复制表结构及其数据:create table table_name_new as select * from table_name_old 只复制表结构:create table table_name_new as select * from table_name_old where 1=2;...
oracle语句
insert
into
select
如何加后续插入条件?
答:
A中有3例,B表中你只能获得2列,可以用常量占位解决
insert
intotableA(列1,列2,列3)
select
列1,列2,常量 fromtableB例:如下 insertintotableA(列1,列2,列3)select列1,列2,'123' fromtableB【字符串常量】insertintotableA(列1,列2,列3)select列1,列2,123 fromtableB【数值常量...
insert
into from和insert into
select
有什么区别?
答:
备份表数据: create table emp as
select
* from scott.emp 还原表数据:
insert
into emp select * from scott.emp 复制表结构及其数据:create table table_name_new as select * from table_name_old 只复制表结构:create table table_name_new as select * from table_name_old where 1=2;...
select
*from和
insert
into from的区别
答:
备份表数据: create table emp as
select
* from scott.emp 还原表数据:
insert
into emp select * from scott.emp 复制表结构及其数据:create table table_name_new as select * from table_name_old 只复制表结构:create table table_name_new as select * from table_name_old where 1=2;...
“
INSERT
INTO
SELECT
FROM ”这短语怎么用?
答:
备份表数据: create table emp as
select
* from scott.emp 还原表数据:
insert
into emp select * from scott.emp 复制表结构及其数据:create table table_name_new as select * from table_name_old 只复制表结构:create table table_name_new as select * from table_name_old where 1=2;...
Oracle
Insert
Into
select
非常慢
答:
给条件的字段加上索引能提高这个查询效率,如EFEE_ESCO_ID,EFEE_EBAP_CODE。这样的批处理问题,如果数据量比较大的情况下,考虑创建分区也行,数据量不是很大的话,直接加索引就行,
<上一页
1
2
3
4
5
6
7
8
9
10
下一页
尾页
其他人还搜